www.gusucode.com > 婚庆仪礼策划公司网站系统源代码 梦紫色 > 婚庆仪礼策划公司网站系统源代码 梦紫色/Admin/inc/p_body.asp
<%sub p_body()
dim totalnews,Currentpage,totalpages,i
sql="select * from p_class order by orders ASC,p_id asc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<HTML>
<HEAD>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<style type="text/css">
A{TEXT-DECORATION: none}
A:link {COLOR: #666666; FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:visited {COLOR: #666666; FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:active {FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:hover {BORDER-BOTTOM: 1px dotted; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-WIDTH: 1px; COLOR: #ff6600; TEXT-DECORATION: none}
BODY {
FONT-SIZE: 12px;
COLOR: #666666;
FONT-FAMILY: 宋体;
background-color: #ffffff;
background-image: url(images/show.gif);
SCROLLBAR-FACE-COLOR: #e8e7e7;
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
SCROLLBAR-SHADOW-COLOR: #ffffff;
SCROLLBAR-3DLIGHT-COLOR: #cccccc;
SCROLLBAR-ARROW-COLOR: #ff6600;
SCROLLBAR-TRACK-COLOR: #EFEFEF;
SCROLLBAR-DARKSHADOW-COLOR: #b2b2b2;
SCROLLBAR-BASE-COLOR: #000000
}
TABLE {BORDER-COLLAPSE: collapse; FONT-FAMILY: 宋体; FONT-SIZE: 9pt}
.button{height:18px;width:62px;background:#f6f6f9 url(images/ButtonBg.gif); border:solid 1px #5589AA;color: #000000 ;FONT-SIZE: 9pt}
.lanyu{border:solid 1px #5589AA;color: #000000 ; font-size: 12px;}
.font { filter: DropShadow(Color=#cccccc, OffX=2, OffY=1, Positive=2); text-decoration: none; font-size: 9pt}
</style>
<LINK href="inc/djcss.css" type=text/css rel=StyleSheet>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</HEAD>
<body onkeydown=return(!(event.keyCode==78&&event.ctrlKey)) background=inc/dj_bg.gif>
<table align="center" width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<tr>
<td bgcolor="#E8E8E8">服务分类</font></td>
<td bgcolor="#E8E8E8" colspan="5"> </td>
</tr>
<tr bgcolor="#E8E8E8" align="center">
<td class="chinese" width="10%" bgcolor="#F5F5F5">编号</td>
<td colspan="2" bgcolor="#F5F5F5" class="chinese">类别名称</td>
<td class="chinese" width="10%" bgcolor="#F5F5F5">排序</td>
<td class="chinese" width="10%" bgcolor="#F5F5F5">操作</td>
</tr>
<%if Not rs.EOF then
dim newsperpage
newsperpage=10
rs.movefirst
rs.pagesize=newsperpage
if trim(request("page"))<>"" then
page1=trim(request("page"))
if check_num(page1)=true then
currentpage=clng(request("page"))
if currentpage>rs.pagecount then
currentpage=rs.pagecount
End if
else
currentpage=1
end if
else
currentpage=1
End if
totalnews=rs.recordcount
if currentpage<>1 then
if (currentpage-1)*newsperpage<totalnews then
rs.move(currentpage-1)*newsperpage
dim bookmark
bookmark=rs.bookmark
End if
End if
if (totalnews mod newsperpage)=0 then
totalpages=totalnews\newsperpage
else
totalpages=totalnews\newsperpage+1
End if
i=0
Do While Not rs.EOF and i<newsperpage%>
<tr>
<td bgcolor="#FFFFFF" class="chinese" align="center"><%=rs("p_id")%></td>
<td width="28%" bgcolor="#FFFFFF" class="chinese"><font color="#FF0000"><strong></strong></font></td>
<td width="42%" bgcolor="#FFFFFF" class="chinese"><font color="#FF0000"><strong><%=rs("p_type")%></strong></font></td>
<td align="center" bgcolor="#FFFFFF" class="chinese"><%= rs("orders") %> </td>
<td align="center" bgcolor="#FFFFFF" class="chinese"><a href="admin_p.asp?id=<%=rs("p_id")%>&action=editp#editp">修改</a>
<a href="admin_p.asp?id=<%=rs("p_id")%>&action=delp#delp">删除</a></td>
</tr>
<%i=i+1
rs.movenext
loop
else
if rs.EOF and rs.BOF then%>
<tr align="center">
<td bgcolor="#FFFFFF" colspan="5" class="chinese">当前没有分类！</td>
</tr>
<%End if
End if%>
</table>
<table align="center" width="98%" border="0" cellspacing="0" cellpadding="0">
<form name="form2" method="post" action="admin_p.asp"><tr>
<td class="chinese" align="right"><%=currentpage%> /<%=totalpages%>页,<%=totalnews%>条记录/<%=newsperpage%>篇每页.
<%
i=1
showye=totalpages
if showye>10 then
showye=10
End if
for i=1 to showye
if i=currentpage then
%>
<%=i%>
<%else%>
<a href="admin_p.asp?page=<%=i%>"><%=i%></a>
<%End if
next
if totalpages>currentpage then
if request("page")="" then
page=1
else
page=request("page")+1
End if%>
<a href="admin_p.asp?page=<%=page%>" title="下一页">>></a>
<%End if%>
<input type="text" name="page" class="textarea" size="4">
<input type="submit" name="Submit" value="Go" class="button"></td>
</tr>
</form>
</table>
<br>
<%if request.QueryString("action")="newp" then%>
<table align="center" width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td bgcolor="#E8E8E8"><a name="newp">新的分类</a></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">分类名称 :
<input name="p_type" type="text" class="textarea" size="20">
<input name="p_type_e" type="text" class="textarea" id="p_type_e" size="20" style="display:none;">
排序：
<input type="text" name="paixu" id="paixu" style="width:30px" value="1">
<span class="STYLE1">(只能为数字，数字小的排在前面，大的排在后面)</span></td>
</tr>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input type="submit" name="Submit2" value="确定新增" class="button">
<input type="reset" name="Reset" value="清空重填" class="button">
</td>
</tr>
<input type="hidden" name="action" value="newp">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%End if
if request.QueryString("action")="editp" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
Call diserror()
response.End
else
if Not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的ID参数！"
Call diserror()
response.End
End if
End if
sql="select * from p_class where p_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table align="center" width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td bgcolor="#E8E8E8"><a name="editp">修改分类</a></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">分类名称:
<input type="text" name="p_type" size="20" class="textarea" value="<%=rs("p_type")%>">
<input name="p_type_e" type="text" class="textarea" id="p_type_e" value="<%=rs("p_type_e")%>" size="20" style="display:none;">
排序：
<input name="paixu" type="text" id="paixu" style="width:30px" value="<%=rs("orders")%>">
<span class="STYLE1">(只能为数字，数字小的排在前面，大的排在后面)</span></td>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input type="submit" name="Submit" value="确定修改" class="button">
<input type="reset" name="Reset" value="清空重填" class="button">
[<a href="admin_p.asp">返回</a>] </td>
</tr>
<input type="hidden" name="id" value="<%=rs("p_id")%>">
<input type="hidden" name="action" value="editp">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%End if
if request.QueryString("action")="delp" then
if request.querystring("id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
Call diserror()
response.End
else
if Not isinteger(request.querystring("id")) then
errmsg=errmsg+"<br>"+"<li>非法的ID参数！"
Call diserror()
response.End
End if
End if
sql="select * from p_class where p_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
<table align="center" width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<form name="form1" method="post" action="">
<tr>
<td bgcolor="#E8E8E8"><a name="delp" id="delp">删除分类</a> 注意：删除分类将同时删除分类内容,建议你使用修改功能！</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" class="chinese">分类名称: </td>
</tr>
<tr>
<td bgcolor="#F5F5F5" class="chinese" height="30" align="center">
<input name="Submit" type="submit" class="button" id="Submit" value="确定删除">
[<a href="admin_p.asp">返回</a>] </td>
</tr>
<input type="hidden" name="id" value="<%=rs("p_id")%>">
<input type="hidden" name="action" value="delp">
<input type="hidden" name="MM_insert" value="true">
</form>
</table>
<%End if
%>
<br>
</td>
</tr>
<tr>
<td colspan="3" height="1" background="images/dotlineh.gif"></td>
</tr>
</table>
<%
rs.close
set rs=Nothing
End sub
%>